{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["BASIC DATA","FF-1 (S&U)","FF-2 (MCC)","FF-3 (MAE)","FF-4 (MDPP)","FF-5 (DEBT SERVICE)","FF-6 (CERTIFICATION)"],"not_rendered":{"charts":0,"images":30,"macros":1,"external_links":0,"defined_names":20,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BASIC DATA","index":0,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[24,2,25,9],[2,1,2,9],[13,5,13,7],[7,5,7,6],[9,5,9,8],[11,5,11,8]]}
[]
[]
[null,"FINANCIAL FEASIBLITY FORMS"]
[]
[null,"Please complete the following information before proceeding:"]
[]
[]
[null,null,"Application Date:"]
[]
[null,null,"Ownership Entity:"]
[]
[null,null,"Development Name:"]
[]
[null,null,"Development County:"]
[]
[null,null,"Type of Construction:",null,null,1]
[]
[null,null,"Development Type:",null,null,1]
[]
[null,null,"Target Population:",null,null,1]
[]
[null,null,"Total Number of Units:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"New Construction"]
[null,"Moderate Rehabilitation"]
[null,"Substantial Rehabilitation (stripped to studs)"]
[null,"Historic Rehabilitation"]
[]
[null,"Multifamily"]
[null,"Single-Family (Attached)"]
[null,"Single-Family (Detached)"]
[]
[null,"Family"]
[null,"Elderly/Persons with Disabilities"]

{"sheet":"FF-1 (S&U)","index":1,"n_rows":60,"n_cols":16,"rows_kept":60,"cut":false,"hidden":false,"merged":[[8,2,8,13],[9,2,9,13],[6,2,6,13],[7,2,7,13]]}
[]
[]
[null,null,null,null,null,"MISSISSIPPI HOME CORPORATION"]
[null,null,null,null,null,"Housing Tax Credit Program"]
[null,null,null,null,null,"Financial Feasibility Form FF-1"]
[]
[]
[null,null,"SOURCES AND USES"]
[null,null,{"$f":"IF('BASIC DATA'!F12=\"\",\"\",'BASIC DATA'!F12)","v":""}]
[null,null,{"$f":"IF('BASIC DATA'!F8=\"\",\"\",'BASIC DATA'!F8)","v":""}]
[null,null,null,"SOURCES OF FUNDS"]
[null,null,null,"Loans"]
[null,null,null,"Federal Grants",null,null,null,null,null,null,0]
[null,null,null,"State/Local Grants",null,null,null,null,null,null,0]
[null,null,null,"Historic Tax Credits Syndication Proceeds",null,null,null,null,null,null,0]
[null,null,null,"Deferred Developer Fee",null,null,null,null,null,null,0]
[null,null,null,"Other Soft Financing",null,null,null,null,null,null,0]
[null,null,null,"Total Sources:  (excluding housing tax credits syndication proceeds)",null,null,null,null,null,null,{"$f":"SUM(K12:K17)","v":0},{"$f":"IF(K50=0,\"\",P20/K50)","v":""}]
[]
[null,null,null,"USES OF FUNDS",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K12+K15+K13+K14+K17","v":0}]
[null,null,null,"Hard Cost Total (from pg A15 of Application)"]
[]
[null,null,null,"Builder's Profit"]
[null,null,null,"     Builder's Profit"]
[null,null,null,"     Builder's Overhead"]
[null,null,null,"     General Requirements"]
[null,null,null,"Builder's Profit Total",null,null,null,null,null,null,{"$f":"SUM(K24:K26)","v":0}]
[]
[null,null,null,"Construction Contract Total",null,null,null,null,null,null,{"$f":"K21+K27","v":0}]
[]
[null,null,null,"Soft Costs"]
[null,null,null,null,"Acquisition"]
[null,null,null,null,"Architectural Fees"]
[null,null,null,null,"Survey and Engineering"]
[null,null,null,null,"Permanent Financing Cost and Fees"]
[null,null,null,null,"Construction Loan Interest and Fees"]
[null,null,null,null,"Closing Cost, Legal Fees and Bond Premium",null,null,null,null,null,0]
[null,null,null,null,"Appraisal",null,null,null,null,null,0]
[null,null,null,null,"Reserves"]
[null,null,null,null,"Developer's Fees "]
[null,null,null,null,"Land Acquisition"]
[null,null,null,null,"Syndication Cost"]
[null,null,null,null,"Market Study"]
[null,null,null,null,"Environmental Report"]
[null,null,null,null,"Tenant Relocation Fees"]
[null,null,null,null,"Tax Credit Fees"]
[null,null,null,null,"Other Costs"]
[null,null,null,"Total Soft Costs",null,null,null,null,null,null,{"$f":"SUM(K32:K47)","v":0}]
[]
[null,null,null,"Total Uses:",null,null,null,null,null,null,{"$f":"K21+K27+K48","v":0}]
[]
[null,null,null,"Gap:",null,null,null,null,null,null,{"$f":"K50-K18","v":0}]
[]
[null,null,null,"Estimated Market Value of Tax Credits (cents per dollar):"]
[]
[null,null,null,"Investor Percentage:",null,null,null,null,null,null,0.99990000000000001]
[]
[null,null,null,"Soft Cost/Hard Cost Ratio ((SC-L-ACQ+BPT) / (HC+ACQ+L)):",null,null,null,null,null,null,{"$f":"((K48-K41-K32+K27) / (K21+K32+K41))","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Estimated Amount of Annual Tax Credits Needed:",null,null,null,null,null,null,{"$f":"IF(K54=0,\"\",K52/10/K54/K56)","v":""}]

{"sheet":"FF-2 (MCC)","index":2,"n_rows":58,"n_cols":42,"rows_kept":58,"cut":false,"hidden":false,"merged":[[6,2,6,22],[8,2,8,22],[44,12,44,15],[28,19,28,20],[40,3,40,21],[38,19,38,20],[26,19,26,20],[9,2,9,22],[10,2,10,22],[11,2,11,22],[14,3,14,21],[30,3,30,21],[18,19,18,20],[19,19,19,20],[42,37,42,38],[34,25,34,27],[41,37,41,38],[36,38,36,39],[60,4,60,21],[52,17,52,18],[48,3,48,21],[50,4,50,21],[57,4,57,21],[18,32,18,34],[22,19,22,20],[23,19,23,20],[42,12,42,15],[46,19,46,20],[43,12,43,15],[27,19,27,20]]}
[]
[]
[null,null,null,null,null,null,null,"MISSISSIPPI HOME CORPORATION"]
[null,null,null,null,null,null,null,"Housing Tax Credit Program"]
[null,null,null,null,null,null,null,"Financial Feasibility Form FF-2"]
[]
[]
[]
[null,null,"MAXIMUM CONSTRUCTION COSTS (MCC)"]
[null,null,{"$f":"IF('BASIC DATA'!F12=\"\",\"\",'BASIC DATA'!F12)","v":""}]
[null,null,{"$f":"IF('BASIC DATA'!F8=\"\",\"\",'BASIC DATA'!F8)","v":""}]
[null,null,"Maximum Construction Costs are calculated based on the criteria listed below.  If the development's estimated hard costs per unit exceed the established limits, then all factors that contribute to the excess per unit cost (e.g. exceptionally high land costs, material costs, special wage rates) are required to be disclosed and fully explained.  Justification for the excess cost must be certified by the development's architect.  Excessive land development costs must be certified by an engineer."]
[]
[]
[null,null,null,"MAXIMUM CONSTRUCTION COST (MCC) LIMITS"]
[]
[]
[null,null,null,null,null,null,"NEW CONSTRUCTION MULTIFAMILY DEVELOPMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost per Unit"]
[null,null,null,null,null,null,null,"Family……………………………………………………………………………………………………………………….",null,null,null,null,null,null,null,null,null,null,null,170400,null,null,null,null,null,null,"Dev Type",null,null,null,null,null,"Const Type",null,null,null,null,null,null,"Population"]
[null,null,null,null,null,null,null,"Elderly/Persons with Disabilities……………………………………………………………………………..",null,null,null,null,null,null,null,null,null,null,null,130800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG25=\"x\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,1,null,null,null,null,1,null,null,{"$f":"IF(AL23=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,"NEW CONSTRUCTION SINGLE-FAMILY DEVELOPMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BASIC DATA'!F18=2,\"x\",\"\")","v":""},2,"MF",null,null,null,{"$f":"IF('BASIC DATA'!F16=2,\"X\",\"\")","v":""},2,"New Construction",null,null,{"$f":"IF('BASIC DATA'!F20=2,\"x\",\"\")","v":""},2,"Family",null,{"$f":"SUM(AP20:AP21)","v":0}]
[null,null,null,null,null,null,null,"Single Family - Attached (Townhomes/Duplexes/4-plex)……………………………………..",null,null,null,null,null,null,null,null,null,null,null,164400,null,null,null,null,null,null,{"$f":"IF('BASIC DATA'!F18=3,\"x\",\"\")","v":""},3,"SF-A",null,null,null,{"$f":"IF('BASIC DATA'!F16=3,\"X\",\"\")","v":""},3,"Moderate Rehabilitation",null,null,{"$f":"IF('BASIC DATA'!F20=3,\"x\",\"\")","v":""},3,"Elderly/Disabled"]
[null,null,null,null,null,null,null,"Single Family - Detached………………………………………………………………………………………",null,null,null,null,null,null,null,null,null,null,null,182400,null,null,null,null,null,null,{"$f":"IF('BASIC DATA'!F18=4,\"x\",\"\")","v":""},4,"SF-D",null,null,null,{"$f":"IF('BASIC DATA'!F16=4,\"X\",\"\")","v":""},4,"Substantial Rehabilitation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BASIC DATA'!F16=5,\"X\",\"\")","v":""},5,"Historic Rehabilitation"]
[null,null,null,null,null,null,"REHABILITATION DEVELOPMENTS"]
[null,null,null,null,null,null,null,"Moderate Rehabilitation..………………………………………………………………………………………..",null,null,null,null,null,null,null,null,null,null,null,58200]
[null,null,null,null,null,null,null,"Substantial Rehabilitation (stripped to the studs)………………...……………………………….",null,null,null,null,null,null,null,null,null,null,null,125400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multifamily","Single Family",null,"AN28","SF-A","SF-D"]
[null,null,null,null,null,null,null,"Historic Rehabilitation…………………………………………………………………………………………….",null,null,null,null,null,null,null,null,null,null,null,181200,null,null,null,null,null,"Dev Type",null,null,{"$f":"'BASIC DATA'!F18","v":1},null,{"$f":"IF(AC29>1,\"True\",\"\")","v":""},null,null,null,null,{"$f":"IF(AC29=2,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AC29>2,\"Yes\",\"No\")","v":"No"},null,"AN29",{"$f":"IF(AC29=3,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AC29=4,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction",null,null,{"$f":"'BASIC DATA'!F16","v":1},null,{"$f":"IF(AC30>1,\"True\",\"\")","v":""}]
[null,null,null,"DEVELOPMENT'S ALLOWABLE MAXIMUM CONSTRUCTION COST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Population",null,null,{"$f":"'BASIC DATA'!F20","v":1},null,{"$f":"IF(AC31>1,\"True\",\"\")","v":""},null,null,null,null,"NC","AR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC30=2,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AC30>=3,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,{"$f":"C10","v":""}]
[null,null,null,null,null,null,null,null,"Development Type:",null,null,null,{"$f":"IF(AE29=\"TRUE\",(IF(AC29=2,\"Multifamily\",\"Single Family\")),\"\")","v":""},null,null,{"$f":"IF(AK29=\"Yes\",(IF(AO29=\"Yes\",\"[Detached]\",\"[Attached]\")),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Construction Type:",null,null,null,{"$f":"VLOOKUP('BASIC DATA'!F16,AH21:AI25,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(T39*0.1)+T39","v":0}]
[null,null,null,null,null,null,null,null,"Targeted Population:",null,null,null,{"$f":"IF(AE31=\"True\",(IF(AC31=3,\"Elderly/Persons with Disabilities\",\"Family\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Family","Elderly/Dis",null,null,"AJ41"]
[null,null,null,null,null,null,null,null,"Number of Units:",null,null,null,{"$f":"IF('BASIC DATA'!F22=\"\",\"\",'BASIC DATA'!F22)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC31=2,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AC31=3,\"Yes\",\"No\")","v":"No"},"AK37",{"$f":"IF(AK37=\"Yes\",105500,0)","v":0}]
[]
[null,null,null,null,null,"Maximum Allowable Construction Cost Per Unit……………………………………………………………..",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC49","v":0}]
[]
[null,null,null,"DEVELOPMENT'S PROPOSED CONSTRUCTION COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elderly","Historic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family-A",null,null,{"$f":"IF(AN29=\"Yes\",(IF(AK45<1,MAX(AD42,AE42,AF42,\"0\"),0)),0)","v":0},{"$f":"IF(AN29=\"Yes\",164400,0)","v":0},{"$f":"IF($AK$37=\"Yes\",105500,0)","v":0},{"$f":"IF($AN$43=\"Yes\",164400,0)","v":0},null,null,{"$f":"IF(AK37=\"Yes\",1,0)","v":0},"New Const","Mod Rehab","Sub Rehab",null,"Hist Rehab"]
[null,null,null,null,null,null,null,null,"Total Hard Costs:",null,null,null,{"$f":"IF('FF-1 (S&U)'!K21=\"\",\"\",'FF-1 (S&U)'!K21)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Single Family-D",null,null,{"$f":"IF(AO29=\"Yes\",(IF(AK45<1,MAX(AD43,AE43,AF43,\"0\"),0)),0)","v":0},{"$f":"IF(AO29=\"Yes\",182400,0)","v":0},{"$f":"IF($AK$37=\"Yes\",105500,0)","v":0},{"$f":"IF($AN$43=\"Yes\",182400,0)","v":0},null,null,null,{"$f":"IF('BASIC DATA'!F16=2,\"Yes\",\"No\")","v":"No"},{"$f":"IF('BASIC DATA'!F16=3,\"Yes\",\"No\")","v":"No"},{"$f":"IF('BASIC DATA'!F16=4,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF('BASIC DATA'!F16=5,\"Yes\",\"No\")","v":"No"},"AN43"]
[null,null,null,null,null,null,null,null,"Total Builder's Profit and Soft Costs:",null,null,null,{"$f":"'FF-1 (S&U)'!K27+'FF-1 (S&U)'!K48","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"MF NC Family",null,null,{"$f":"IF(AK49=\"MNC\",(IF(AJ37=\"Yes\",MAX(AD44,AE44,AF44,0),0)),0)","v":0},{"$f":"IF(AK49=\"MNC\",170400,0)","v":0},{"$f":"IF($AK$37=\"Yes\",105500,0)","v":0},{"$f":"IF($AN$43=\"Yes\",170400,0)","v":0},null,null,null,null,{"$f":"IF(AK43=\"yes\",1,0)","v":0},{"$f":"IF(AL43=\"Yes\",1,0)","v":0},null,{"$f":"IF(AN43=\"Yes\",131600,0)","v":0},"AN44"]
[null,null,null,null,null,null,null,null,"Total Development Costs:",null,null,null,{"$f":"M43+M44","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"MF NC Elderly",null,null,{"$f":"IF(AK49=\"MNC\",(IF(AK37=\"Yes\",MAX(AD45,AE45,AF45,0),0)),0)","v":0},{"$f":"IF(AK49=\"MNC\",130800,0)","v":0},{"$f":"IF($AK$37=\"Yes\",109000,0)","v":0},{"$f":"IF($AN$43=\"Yes\",130800,0)","v":0},null,null,null,null,{"$f":"AL44+AK44","v":0},"AK45"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MF Mod Rehab",null,null,{"$f":"IF(AK43=\"yes\",58200,0)","v":0}]
[null,null,null,null,null,null,"Development's Proposed Construction Hard Cost Per Unit………………………………………….",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M43=0,\"\",M43/M37)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"MF Sub Rehab",null,null,{"$f":"IF(AL43=\"Yes\",125400,0)","v":0},null,{"$f":"IF(AL43=\"Yes\",(IF(AK51=\"MAR\",T28,\"0\")),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MF Hist Rehab",null,null,{"$f":"IF(AN43=\"Yes\",(IF(AG48=0,181200,\"0\")),\"\")","v":""},null,null,null,{"$f":"SUM(AC42:AC47)","v":0}]
[null,null,null,"EXCEEDING MAXIMUM COSTS PER UNIT LIMITS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC42:AC48)","v":0},null,null,null,null,null,null,null,{"$f":"IF(AJ29=\"Yes\",(IF(AJ32=\"Yes\",\"MNC\",\"0\")),\"\")","v":""},null,"Multifamily New Construction"]
[]
[null,null,null,null,"Construction/Rehabilitation hard costs which exceed the Maximum Construction Cost (MCC) per unit by greater than ten percent (10%) must submit a request for approval to MHC by the deadline date outlined in Section 2, Chart 2 of the Qualified Allocation Plan. Points will not be deducted or awarded in cases where an approval is granted.  Failure to receive prior approval will disqualify the application from consideration.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ29=\"Yes\",(IF(AK32=\"Yes\",\"MAR\",\"0\")),\"\")","v":""},null,"Multifamily Acq Rehab"]
[]
[null,null,null,null,null,null,"This development exceeds the maximum allowable cost per unit by:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T47>T39,T47-T39,\"$0\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(M43=0,\"\",R53/T39)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,null,null,null,null,"Justification Needed:",null,null,null,{"$f":"IF(T47>Z35,\"x\",\"\")","v":{"$error":"#VALUE!"}}," Yes*",null,{"$f":"IF(T47<=Z35,\"x\",\"\")","v":{"$error":"#VALUE!"}}," No"]
[]
[null,null,null,null,"*If justification is needed, Applicants must provide the required supporting documentation as outlined in Section 5.6(2)(b) of the QAP.  "]

{"sheet":"FF-3 (MAE)","index":3,"n_rows":69,"n_cols":22,"rows_kept":69,"cut":false,"hidden":false,"merged":[[8,2,8,18],[6,2,6,18],[9,2,9,18],[10,2,10,18],[12,2,12,18]]}
[]
[]
[null,null,null,null,null,null,null,"MISSISSIPPI HOME CORPORATION"]
[null,null,null,null,null,null,null,"Housing Tax Credit Program"]
[null,null,null,null,null,null,null,"Financial Feasibility Form FF-3"]
[]
[]
[]
[null,null,"MAXIMUM ADMINISTRATIVE EXPENSES (MAE)"]
[null,null,{"$f":"IF('BASIC DATA'!F12=\"\",\"\",'BASIC DATA'!F12)","v":""}]
[null,null,{"$f":"IF('BASIC DATA'!F8=\"\",\"\",'BASIC DATA'!F8)","v":""}]
[]
[null,null,"Maximum Administrative Expenses are calculated based on the criteria listed below.  If an application has administrative expenses in excess of the established limits, all factors that contributed to the excess (e.g., exceptionally high insurance costs, maintenance reserves, replacement reserves, significant amenities and/or services, requirement of security, high real estate taxes and/or insurance, etc.) are required to be disclosed and fully explained within the application by a certified CPA.  In addition to a maximum expense per unit, MHC will require a minimum expense per unit of $3,750 that must be maintained throughout the compliance period."]
[]
[null,null,"Check the appropriate box.  Select only one box from each category."]
[]
[]
[null,null,"Development Base (DB)…………………………………………………………………………………………………………..",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U24>5707,0,U24)","v":0}]
[null,null,"(Includes Section 8 - Family, All Elderly/Handicapped, All Family/ Non-Elderly)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U24=9487,\"ERROR\",\"\")","v":""}]
[]
[null,null,null,null,false,null,"Metropolitan Areas",null,null,null,null,null,null,5707,null,null,null,null,null,null,{"$f":"IF(E21=TRUE,N21,\"\")","v":""}]
[]
[null,null,null,null,false,null,"All Other Areas",null,null,null,null,null,null,5140,null,null,null,null,null,null,{"$f":"IF(E23=TRUE,N23,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U21:U23)","v":0}]
[null,null,"Development Designation (DD)………………………………………………………………………………………………",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U34>1,0,V33)","v":0}]
[]
[null,null,null,null,false,null,"All Senior Citizens",null,null,null,null,null,null,0.9,null,null,null,{"$f":"IF(U34>1,\"ERROR\",\"\")","v":""},null,null,{"$f":"IF(E27=TRUE,N27,\"\")","v":""}]
[]
[null,null,null,null,false,null,"Mixed",null,null,null,null,null,null,0.95,null,null,null,null,null,null,{"$f":"IF(E29=TRUE,N29,\"\")","v":""}]
[]
[null,null,null,null,false,null,"Congregate",null,null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(E31=TRUE,N31,\"\")","v":""}]
[]
[null,null,null,null,false,null,"Family",null,null,null,null,null,null,1.05,null,null,null,null,null,null,{"$f":"IF(E33=TRUE,N33,\"\")","v":""},{"$f":"SUM(U27:U33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(U27:U33)","v":0}]
[null,null,"Development Size (DS)…………………………………………………………………………………………………………….",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U44>1,0,V43)","v":0}]
[]
[null,null,null,null,false,null,"50 or more units",null,null,null,null,null,null,0.9,null,null,null,{"$f":"IF(U44>1,\"ERROR\",\"\")","v":""},null,null,{"$f":"IF(E37=TRUE,N37,\"\")","v":""}]
[]
[null,null,null,null,false,null,"33 - 49 units",null,null,null,null,null,null,0.95,null,null,null,null,null,null,{"$f":"IF(E39=TRUE,N39,\"\")","v":""}]
[]
[null,null,null,null,false,null,"24 - 32 units",null,null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(E41=TRUE,N41,\"\")","v":""}]
[]
[null,null,null,null,false,null,"24 - 32 units (scattered sites, different locations/municipalities)",null,null,null,null,null,null,1.05,null,null,null,null,null,null,{"$f":"IF(E43=TRUE,N43,\"\")","v":""},{"$f":"SUM(U37:U43)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(U37:U43)","v":0}]
[null,null,"Management Difficulty (MD)………………………………………………………………………………………………….",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U56>1,0,V55)","v":0}]
[]
[null,null,null,null,false,null,"Full Profit",null,null,null,null,null,null,0.9,null,null,null,{"$f":"IF(U56>1,\"ERROR\",\"\")","v":""},null,null,{"$f":"IF(E47=TRUE,N47,\"\")","v":""}]
[]
[null,null,null,null,false,null,"515 / Market Rate",null,null,null,null,null,null,0.95,null,null,null,null,null,null,{"$f":"IF(E49=TRUE,N49,\"\")","v":""}]
[]
[null,null,null,null,false,null,"Split RA",null,null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(E51=TRUE,N51,\"\")","v":""}]
[]
[null,null,null,null,false,null,"100% RA / Split Section 8",null,null,null,null,null,null,1.05,null,null,null,null,null,null,{"$f":"IF(E53=TRUE,N53,\"\")","v":""}]
[]
[null,null,null,null,false,null,"100% Section 8 / 515",null,null,null,null,null,null,1.1000000000000001,null,null,null,null,null,null,{"$f":"IF(E55=TRUE,N55,\"\")","v":""},{"$f":"SUM(U47:U55)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(U47:U55)","v":0}]
[null,null,"Development Location (DL) ……………………………………………………………………………………………………",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U62>1,0,V61)","v":0}]
[]
[null,null,null,null,false,null,"Harrison, Hancock and Jackson",null,null,null,null,null,null,1.25,null,null,null,{"$f":"IF(U62>1,\"ERROR\",\"\")","v":""},null,null,{"$f":"IF(E59=TRUE,N59,\"\")","v":""}]
[]
[null,null,null,null,false,null,"Other Counties",null,null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(E61=TRUE,N61,\"\")","v":""},{"$f":"SUM(U59:U61)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(U59:U61)","v":0}]
[]
[]
[]
[null,null,"Calculations:"]
[]
[null,null,"Maximum Administrative Expenses (MAE) Per Unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R18*R25*R35*R45*R57","v":0}]
[null,null,"($DB) x (DD) x (DS) x (MD) x (DL) = MAE"]

{"sheet":"FF-4 (MDPP)","index":4,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":false,"merged":[[8,2,8,16],[9,2,9,16],[10,2,10,16],[12,2,12,16]]}
[]
[]
[null,null,null,null,null,null,null,"MISSISSIPPI HOME CORPORATION"]
[null,null,null,null,null,null,null,"Housing Tax Credit Program"]
[null,null,null,null,null,null,null,"Financial Feasibility Form FF-4"]
[]
[]
[]
[null,null," MAXIMUM DEVELOPER PROFIT PERCENTAGE (MDPP)"]
[null,null,{"$f":"IF('BASIC DATA'!F12=\"\",\"\",'BASIC DATA'!F12)","v":""}]
[null,null,{"$f":"IF('BASIC DATA'!F8=\"\",\"\",'BASIC DATA'!F8)","v":""}]
[]
[null,null,"MHC will allow a base fee of fifteen percent (15%) of the development's construction costs, incuding builder's profit, for developer's fees which includes developer's overhead and consultant fees.  This base fee may be increased dependent upon the development size.  For developments which qualify for acquisition credits, MHC will permit a flat developer fee of ten percent (10%) on the development's allowable acquisition cost."]
[]
[]
[null,null,"Base Fee...……………………………………………………………………………………………………………………………..",null,null,null,null,null,null,null,null,null,null,null,null,null,0.15]
[]
[]
[null,null,"Please select only one from each category."]
[]
[null,null,"Development Size (DS)…………………………………………………………………………………………………………",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S29>1,0,T27)","v":0}]
[]
[null,null,null,null,false,null,"33 or more units",null,null,null,null,null,null,null,1,null,{"$f":"IF(S29>1,\"ERROR\",\"\")","v":""},null,{"$f":"IF(E23=TRUE,O23,\"\")","v":""}]
[]
[null,null,null,null,false,null,"24 - 32 units",null,null,null,null,null,null,null,1.1000000000000001,null,null,null,{"$f":"IF(E25=TRUE,O25,\"\")","v":""}]
[]
[null,null,null,null,false,null,"24 - 32 units (scattered sites, different locations/municipalities)",null,null,null,null,null,null,null,1.2,null,null,null,{"$f":"IF(E27=TRUE,O27,\"\")","v":""},{"$f":"SUM(S23:S27)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(S23:S27)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Calculations:"]
[]
[null,null,"Maximum Developer Profit Percentage (MDPP)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q16*Q21","v":0}]
[null,null,"Base (15%) x (DS) = MDPP"]

{"sheet":"FF-5 (DEBT SERVICE)","index":5,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[25,3,25,15],[15,5,15,15],[17,5,17,15],[8,2,8,15],[18,5,18,15],[16,7,16,15],[9,2,9,15],[10,2,10,15],[12,2,12,15]]}
[]
[]
[null,null,null,null,null,null,null,"MISSISSIPPI HOME CORPORATION"]
[null,null,null,null,null,null,null,"Housing Tax Credit Program"]
[null,null,null,null,null,null,null,"Financial Feasibility Form FF-5"]
[]
[]
[]
[null,null," DEBT SERVICE COVERAGE RATIO (DSCR)"]
[null,null,{"$f":"IF('BASIC DATA'!F12=\"\",\"\",'BASIC DATA'!F12)","v":""}]
[null,null,{"$f":"IF('BASIC DATA'!F8=\"\",\"\",'BASIC DATA'!F8)","v":""}]
[]
[null,null,"All developments must reflect a 15-year average Debt Service Coverage Ratio (DSCR) between 1.15 and 1.30.  A development will not be considered financially feasible if the average DSCR does not fall within the aforementioned range.  "]
[]
[]
[null,null,null,null,null,"The above referenced proposed tax credit development's average DSCR falls within the required range."]
[]
[null,null,null,null,null,"The above referenced proposed tax credit development exceeds the debt service beyond the acceptable"]
[null,null,null,null,null,"acceptable range.  At the time of reservation, the developer will:"]
[]
[null,null,null,null,null,null,null,null,null,"obtain a higher permanent mortgage supported by a debt service coverage within the"]
[null,null,null,null,null,null,null,null,null,"acceptable range, or"]
[]
[null,null,null,null,null,null,null,null,null,"reduce the rents that would be charged to the tenant."]
[]
[null,null,null,"A development is not considered feasible for tax credits if the average debt service coverage ratio does not fall within the aforementioned range.  The minimum debt service coverage ratio will be enforced."]
[null,null,null,"Maximum Supportable Mortgage Worksheet"]
[]
[null,null,null,null,null,null,null,null,null,null,"Year","Amount Available for Debt Service","Debt Service Payment","DSCR"]
[null,null,null,null,null,null,null,null,null,null,1,0,0,{"$f":"IF(L30=0,\"\",L30/M30)","v":""}]
[null,null,null,null,null,null,null,null,null,null,2,0,0,""]
[null,null,null,null,null,null,null,null,null,null,3,0,0,""]
[null,null,null,null,null,null,null,null,null,null,4,0,0,""]
[null,null,null,null,null,null,null,null,null,null,5,0,0,""]
[null,null,null,null,null,null,null,null,null,null,6,0,0,""]
[null,null,null,null,null,null,null,null,null,null,7,0,0,""]
[null,null,null,null,null,null,null,null,null,null,8,0,0,""]
[null,null,null,null,null,null,null,null,null,null,9,0,0,""]
[null,null,null,null,null,null,null,null,null,null,10,0,0,""]
[null,null,null,null,null,null,null,null,null,null,11,0,0,""]
[null,null,null,null,null,null,null,null,null,null,12,0,0,""]
[null,null,null,null,null,null,null,null,null,null,13,0,0,""]
[null,null,null,null,null,null,null,null,null,null,14,0,0,""]
[null,null,null,null,null,null,null,null,null,null,15,0,0,""]
[null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(L30:L44)","v":0},{"$f":"SUM(M30:M44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Avg:",{"$f":"L45/15","v":0},{"$f":"M45/15","v":0},{"$f":"IF(N44=\"\",\"\",AVERAGE(N30:N44))","v":""}]

{"sheet":"FF-6 (CERTIFICATION)","index":6,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,2,8,17],[9,2,9,17],[14,2,14,16],[28,2,28,13],[33,2,33,16],[25,15,25,16],[17,15,17,16],[21,15,21,16],[23,15,23,16],[19,15,19,16],[10,2,10,17],[12,2,12,17],[46,7,46,9],[31,2,31,16],[40,5,40,12],[41,8,41,12],[43,7,43,12]]}
[]
[]
[null,null,null,null,null,null,null,"MISSISSIPPI HOME CORPORATION"]
[null,null,null,null,null,null,null,"Housing Tax Credit Program"]
[null,null,null,null,null,null,null,"Financial Feasibility Form FF-6"]
[]
[]
[]
[null,null,"Financial Feasiblity Certification"]
[null,null,{"$f":"IF('BASIC DATA'!F12=\"\",\"\",'BASIC DATA'!F12)","v":""}]
[null,null,{"$f":"IF('BASIC DATA'!F8=\"\",\"\",'BASIC DATA'!F8)","v":""}]
[]
[null,null,"Pursuant to IRC §42(m)(2), the housing credit dollar amount allocated to a development shall not exceed the amount the housing credit agency determines is necessary for the financial feasibility of the development and its viability as a qualified low-income housing development throughout the credit period.  All developments are held to the standards under the QAP in which the credits were awarded.  A development will not be considered financially feasible if these standards are not met."]
[]
[null,null,"The following forms have been computed and are being submitted with the HTC Application:"]
[]
[]
[null,null,null,null,null,null,"Form FF-1:  Sources and Uses Statement",null,null,null,null,null,null,null,"Tax Credits Needed= ",{"$f":"IF('FF-1 (S&U)'!K60=\"\",\"\",'FF-1 (S&U)'!K60)","v":""}]
[]
[null,null,null,null,null,null,"Form FF-2:  Maximum Construction Cost Per Unit (MCC)",null,null,null,null,null,null,null,"MCC= ",{"$f":"IF('FF-2 (MCC)'!T47=\"\",\"\",'FF-2 (MCC)'!T47)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,"Form FF-3:  Maximum Administrative Expenses Per Unit (MAE)",null,null,null,null,null,null,null,"MAE= ",{"$f":"IF('FF-3 (MAE)'!R68=0,\"\",'FF-3 (MAE)'!R68)","v":""}]
[]
[null,null,null,null,null,null,"Form FF-4:  Maximum Developer Profit Percentage (MDPP)",null,null,null,null,null,null,null,"MDPP= ",{"$f":"IF('FF-4 (MDPP)'!Q60=0,\"\",'FF-4 (MDPP)'!Q60)","v":""}]
[]
[null,null,null,null,null,null,"Form FF-5:  Debt Service Underwriting Criteria",null,null,null,null,null,null,null,"Avg DSCR= ",{"$f":"IF('FF-5 (DEBT SERVICE)'!N46=\"\",\"\",'FF-5 (DEBT SERVICE)'!N46)","v":""}]
[]
[]
[]
[]
[]
[null,null,"ACKNOWLEDGEMENT AND CERTIFICATION"]
[]
[null,null,"The undersigned applicant hereby certifies that the underwriting standards have been satisfied according to the current Qualified Allocation Plan . "]
[]
[]
[null,null,"OWNER"]
[null,null,{"$f":"IF('BASIC DATA'!F10=\"\",\"\",'BASIC DATA'!F10)","v":""}]
[]
[]
[null,null,"By:"]
[null,null,null,null,null,"Printed Name:"]
[]
[null,null,null,"Its:"]
[]
[]
[null,null,"Date:"]